﻿CREATE PROCEDURE [dbo].[GetAuthorsForPublisher]
	@publisherId int
AS
	select	av.*
	from	PublisherAuthor as pa
	inner   join AuthorView as av on av.AuthorId = pa.AuthorId
	where	pa.PublisherId = @publisherId
	order   by av.LastName, av.FirstName;
RETURN 0